SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492335 LIMIT 1 [ RunTime:0.000548s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492335 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619861,749055,1006524,802493,286503,237678,16709,57535,258488,919867,421371,174381,720576,510238,995918,288292,760226,281802,275454,571754,10708,907047,1031438,772153,282426,1042348,1041181,242675,1011126,885317,695342,964564,665057,529095,415641,55823,835499,829928,542196,53674,88141,386403,506247,409002,681436,1036398,188673,261478,253479,1207,451544,301536,35504,919226,553739,676661,458183,494429,899900,365903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]