SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41271 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41271 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200897,547829,930703,76396,59635,950213,951314,357451,792843,722157,243265,15152,731286,189779,416606,419706,152947,197921,354900,1008202,941242,152743,697742,816478,860771,505095,755715,82007,779501,746470,476842,944818,794555,285166,438274,7297,608494,268021,1041743,735759,150475,326949,479707,820903,328456,455121,873604,45955,428630,395485,512546,228008,919350,198232,938189,415066,577593,668444,391656,865067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]