SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560791 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560791 [ RunTime:0.002841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404631,933368,185844,1022382,70398,86517,157771,449405,369316,900355,996895,41836,575633,499620,618265,572328,483494,427110,635330,294473,590082,483734,397335,353773,147090,393325,157782,291726,439413,484155,163201,597401,823098,42899,783350,101697,716266,613140,703909,997715,948816,1036620,204677,496264,230480,846890,32694,677178,774590,925138,56043,802654,509758,191323,1017675,404485,889858,874517,373561,255494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]