SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401100 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401100 [ RunTime:0.002742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048297,697258,616485,625894,713244,859026,736142,6188,305792,733908,956538,823231,933750,885692,259597,745941,528671,656422,814430,236948,214634,191372,353460,949007,159895,314308,593574,456949,47119,610269,697975,923223,674632,675824,52650,548009,546773,33334,995180,988999,760379,326338,968771,4880,860574,575280,100639,787189,269289,186097,1008919,897580,507765,328772,1015841,907792,156317,364475,403274,77518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]