SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329543 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329543 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697635,417733,923974,762889,593920,2460,327855,29100,692683,1035772,754242,429611,508828,861795,111476,669103,749726,507422,227911,765132,736638,624723,329477,536997,471338,811152,195744,2232,135297,141223,606320,662219,577092,629751,592685,774837,788224,876738,685060,706657,196192,830172,45781,693800,976221,533348,155274,1002721,484555,171555,946320,825971,912212,94144,438232,607877,842347,475130,600694,534268) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]