SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587712 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587712 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492032,1024720,994124,558413,422158,94446,842145,697221,50132,785032,665779,185286,627993,774502,679264,972393,1047248,334574,126515,977305,467738,1017830,248899,1045798,425070,476197,980305,546442,905087,575029,542979,194309,692671,86117,779373,895611,379605,299092,247244,98971,12224,515272,801253,113581,379411,761035,755939,521,765596,114501,503014,514579,570023,742337,430831,1024713,77293,423542,454711,120305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]