SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464423 LIMIT 1 [ RunTime:0.002277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464423 [ RunTime:0.006637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247899,946805,290204,105067,76118,926820,106879,735933,680564,649324,923644,632398,550761,411605,618565,997598,547776,834930,620210,778661,1042034,422193,225752,249488,412483,92283,201880,607441,426718,368177,437717,921167,353639,1014922,639891,356090,890694,834066,437827,788717,869350,90190,150949,853531,439144,2937,329071,621436,45728,653698,839633,844829,852369,1028007,267907,365086,1016986,693389,1011050,411470) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]