SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504269 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504269 [ RunTime:0.002356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112112,566924,941194,55494,554140,794568,473720,46526,149301,445806,103703,428545,926846,193803,543096,589613,735653,1013785,143994,137127,163100,906315,535617,646974,249266,87810,351178,110443,342806,876110,988848,550619,87294,13471,18602,423709,135242,371266,167071,846587,398996,783009,1029417,158769,975926,236040,431350,817867,902277,306420,535072,812424,353091,922387,729376,699138,572892,776900,182885,66955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]