SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364813 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364813 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869715,449247,495684,1012068,554023,542422,77228,88377,844881,823443,791630,36881,1033548,532907,22411,1036930,660600,487587,552531,1041082,689380,109974,356475,228877,531146,289540,253494,873396,590555,399071,127221,717607,926856,9597,167463,745601,432937,1031715,777892,1042200,482074,1042537,59825,740567,492331,788971,549833,326066,340771,867963,890745,719596,527294,211062,807182,397833,318639,505074,206575,366709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]