SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504401 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504401 [ RunTime:0.001354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394165,123675,959991,150183,972588,40134,937780,791333,699789,38792,945755,145961,206894,324690,231958,658340,55319,850376,473562,560535,149771,335035,182524,461222,17179,547531,987151,415972,841112,555041,22894,352439,337139,111541,564009,147206,789543,667108,400779,247372,735327,486498,95821,505541,864109,667005,715678,313791,891168,567282,837561,811315,363089,278883,678727,487358,539011,638405,351061,214370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]