SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535823 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535823 [ RunTime:0.002449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648276,13628,217159,974959,532939,921975,815094,497108,169825,344648,297560,937455,281010,232930,959104,245993,162632,460308,299970,352181,672829,350739,309854,605271,755531,479691,576045,724496,362829,101260,832819,1042124,679838,287913,628520,241179,77992,914539,47487,816347,441284,737906,5619,1020913,448773,604797,133564,129824,810162,861106,820237,997151,796368,254333,351614,865898,921586,172131,582333,914616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]