SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556624 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556624 [ RunTime:0.002058s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620442,907305,141535,26473,15429,630330,100054,510553,1009692,617479,53044,124689,138142,646522,597512,288238,341030,746570,701540,254075,100697,662559,1020585,566270,519208,1038308,10636,786314,1017486,891617,789600,462869,535467,319703,867070,256461,558233,768333,972788,693022,603190,768688,53497,360024,766548,617864,532578,19585,810118,111254,805755,829531,329952,806667,335647,1047921,358100,457984,311107,172177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556624 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556624 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]