SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019450 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019450 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321852,614276,482887,731145,225310,270699,168038,221049,559403,354488,6629,675575,884011,1006740,349409,735038,616415,380259,158323,1000341,430913,635585,414195,1032019,725447,169201,862607,848531,876733,407630,988698,82987,304378,533377,695405,647100,969823,258606,155606,642045,432714,493660,940059,565196,241629,278336,623339,896276,401372,619850,583955,580472,1030275,772183,755574,303624,90512,65333,78729,690808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]