SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548730 LIMIT 1 [ RunTime:0.001244s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548730 [ RunTime:0.002501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621045,83825,246822,519867,576705,468807,980572,113068,288347,632028,662470,487654,388315,481050,548170,569779,246746,162002,709926,944456,151162,427923,814269,307165,540443,846363,188754,580222,510418,81176,1043585,483608,646104,534306,248619,251076,447570,517127,117371,281662,628391,656363,180162,493417,727177,545410,680713,584728,697511,577537,120714,208221,360448,803903,54765,902263,817054,951190,479527,628852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]