SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037942 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037942 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801099,67406,140155,739818,62789,771361,445995,937761,152790,300533,833543,302599,886184,173854,812551,328476,100093,665255,733894,205189,998865,291968,1010114,638518,98140,566462,431018,418250,274555,338001,1033567,233616,166598,23526,512052,1018030,29740,323338,162923,425147,317056,121519,561580,471981,363977,898990,828555,676155,567961,971595,76080,864329,1014610,998793,726629,536892,1005883,288555,662621,800117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]