SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497141 LIMIT 1 [ RunTime:0.000679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497141 [ RunTime:0.003765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616363,483295,162126,697142,981531,666135,440384,283992,132301,616173,267603,840107,254758,415878,597140,916990,826363,218584,826522,29873,413605,154635,172867,486424,1003694,160312,456906,748349,1029814,250209,72384,386814,754557,718208,1013003,524972,263809,894075,485476,623208,501728,329570,683750,649894,697927,106027,369219,408031,157420,743317,600924,278085,9704,763447,318721,947469,65489,155732,391210,950129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000417s ]