SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002770s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542184 LIMIT 1 [ RunTime:0.000861s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542184 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183212,492751,712746,498413,225443,884735,636348,1044651,500859,525618,916819,601417,742588,663012,514608,666234,543013,31802,30318,664136,898817,1030062,474168,635087,41346,562281,356996,404598,1022497,910148,102976,959917,661854,583453,1045,142557,645810,33158,1017507,628083,333321,1033648,934860,565777,440658,499351,252181,696032,700122,831615,286565,447053,244678,363381,526106,893285,436681,462959,279740,157266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001437s ]