SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293663 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293663 [ RunTime:0.001370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470869,239868,1010765,1039604,479595,451115,217008,832571,558355,399539,98682,686501,640642,771165,957009,951926,1025302,797341,974365,807556,809653,781847,234016,191828,850631,541429,582436,811826,64181,870221,155266,65300,233792,400441,294935,128037,869196,1007582,263774,634893,433489,394780,863802,412241,637739,992242,64268,460301,803836,1016028,896097,545306,303373,454990,700007,780463,991300,709617,509760,45091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]