SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001766s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295243 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295243 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265653,462183,788237,587093,916044,1002571,498563,378541,358533,120438,481094,981231,526863,536189,944224,800052,627725,145831,51042,1445,596423,254011,513156,979994,390647,202919,324144,70311,993452,48777,636304,473508,55545,612854,595370,481927,702039,310153,830005,802226,416435,529789,562562,638128,137304,208301,339091,722018,897080,554449,748069,503905,921427,25050,603956,107787,328126,109385,706363,796603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]