SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101048 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101048 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739698,117944,848329,34337,989108,621974,595232,725024,67933,728022,94545,907301,259709,498453,217590,513193,711517,145119,947313,72258,962232,233648,1034531,565237,795564,625241,981482,349280,166614,243183,86255,734415,735937,629679,840404,273644,527533,619113,105405,1022948,220862,767389,555399,600209,918467,19716,537893,69141,335876,388654,1045788,356916,559877,919073,740418,461536,582690,454952,914407,647904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]