SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541308 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541308 [ RunTime:0.003438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777969,369796,803777,991897,935383,686309,206512,784985,907665,77296,462928,338531,255215,251934,210650,583389,788824,512740,825507,34023,625824,315337,206517,777194,368124,1038583,257661,568574,818123,482361,925201,194134,854673,862368,703376,522489,1029037,220379,880200,205744,1007785,842438,313362,908893,793096,653209,163847,548307,457158,685613,107493,561773,169221,1002169,942251,151916,872226,738636,996906,808507) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]