SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383718 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383718 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841500,693095,849567,307467,73359,661214,933411,786202,504200,148071,706114,738745,429693,695800,841739,922115,530801,297878,309518,878244,887701,664446,197502,25798,918784,85754,480537,130525,908227,306637,515228,125362,386324,914860,1008091,565338,560824,204487,171754,194317,147231,399679,784053,829706,972646,416124,644478,765848,644469,67364,863941,803414,433252,511222,267642,295507,908648,289017,1027640,778954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000362s ]