SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040983 LIMIT 1 [ RunTime:0.002202s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040983 [ RunTime:0.001376s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929090,901945,249167,820868,993961,430491,274322,576696,521547,304682,26611,483315,958722,617768,174820,441113,104408,313357,54195,190148,379031,402745,1012291,12848,12608,458304,169008,440210,450409,485840,902343,869379,348084,490036,50616,78186,28359,69474,974978,351413,446047,27563,887694,27726,197638,675441,592641,1039541,257035,51847,637724,1017732,44353,202991,921619,752446,473888,352341,734209,268289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010886s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]