SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501434 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501434 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420240,415592,823998,629401,507525,114993,958526,415745,27933,537910,200358,855119,530233,548819,91835,126887,357371,886536,632883,110779,20633,339317,282950,540923,399533,771621,529071,764692,386704,429825,644687,650688,955249,824109,295297,239279,309217,842060,21273,12081,136003,369469,876718,135355,530988,116139,841993,997476,61581,70963,998817,919254,319740,723128,268123,689325,523769,963328,688162,98318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]