SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421341 LIMIT 1 [ RunTime:0.003053s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421341 [ RunTime:0.007001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664114,922621,430420,58913,461921,964232,65019,193435,704555,486006,258627,425988,561297,508283,592225,837063,230838,60500,126997,536660,360327,1004294,559120,62741,554068,35934,495700,503043,517030,562928,1043949,405171,1019330,771436,204898,846774,125887,1047641,307107,1044608,700530,51377,204233,344161,568755,781010,919315,147283,932524,690243,510320,552429,618509,961279,139622,255301,552878,731669,231260,411883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]