SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286508 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286508 [ RunTime:0.003330s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487861,98093,921256,308852,94626,294711,588945,313231,701710,734987,369332,127584,321971,1012571,797466,977929,532853,281073,252562,602419,844173,632688,458105,453101,155031,265803,196528,817111,577414,248321,509761,184377,837300,392750,634163,635106,91223,888702,348654,378634,671116,305302,411369,20446,1039773,415690,773181,783247,303613,368305,186422,912720,763452,764077,1018713,84733,712357,503452,387204,391635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001300s ]