SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198501 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198501 [ RunTime:0.003221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643005,957718,44897,24642,634488,877308,972648,578844,24543,897036,418590,407155,995150,951156,431136,985475,758707,287082,503223,744042,462257,391573,584798,131545,87421,904360,536975,658191,898478,851041,166519,544841,403734,440838,915663,289045,235380,549660,280043,602955,940474,501106,597445,839929,939647,301518,168216,34908,432787,616107,805786,1043293,729878,913979,873538,752057,812578,888798,324155,530112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]