SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111986 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111986 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88603,744457,652309,975295,1021879,872434,580666,975848,68783,250048,981071,599483,235445,820654,200783,191865,311673,375984,991230,187672,506216,332229,334300,410712,826853,433640,100729,597358,667028,703718,79674,438795,501198,691680,450527,593604,412363,951518,1047200,144146,840926,391990,1013517,737092,322834,406395,497422,988432,480432,418829,326528,689406,323090,24287,570131,131504,475800,191886,85143,627846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]