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` = 308243 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308243 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100835,542458,441423,688735,257283,860683,410562,42801,357588,460949,964423,600569,772310,78926,282870,699535,309938,844345,611991,639879,160737,240479,730860,302194,671066,1016045,1032676,169880,487900,682292,672755,218072,1012271,955317,930858,429653,989305,810595,732359,827733,60510,488251,459319,754542,952470,823721,152076,213595,343374,839045,792674,453911,1032954,175784,752544,469023,694486,143708,608989,761205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]