SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344506 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344506 [ RunTime:0.003662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121411,873111,439486,521312,434894,867013,302535,883789,685481,854674,294226,205842,759880,941805,360613,332865,346699,227294,114530,185722,861598,736290,347191,202741,838280,157847,238445,694201,880900,597614,762074,139443,827602,952966,897015,253006,935640,972749,307973,861680,596205,626320,238523,1012305,11035,732786,85789,811116,593541,490704,923819,188826,844833,593342,251603,449346,187586,357851,66096,997653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002987s ]