SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040705 LIMIT 1 [ RunTime:0.001044s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040705 [ RunTime:0.001570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930838,994841,766970,231835,561151,206723,360600,885180,476536,387199,728915,61112,667551,350479,604758,35911,786178,861322,1045616,979920,355542,516533,267907,629516,251937,18429,631097,1045061,233571,232034,656968,116783,458622,982298,565006,290104,101099,693978,415945,566164,59708,825434,17590,926021,111877,497084,731164,713015,359641,120188,413472,403033,530497,95796,51241,245039,809646,623232,1022234,846842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.032545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001973s ]