SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103417 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103417 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7163,806731,720875,487033,199120,7893,378333,646313,695749,664173,188671,966150,666266,135080,162116,394964,267116,811099,287637,907655,409395,859372,216807,125548,314185,148396,941108,904038,68961,45477,618578,720464,742518,858574,349611,996149,168391,798950,959050,559609,935193,297213,239884,43241,617414,449937,814661,644756,500940,911176,356245,457192,237628,263299,237957,194066,219678,437268,951496,1000823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]