SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017366 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017366 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513955,23,810123,896921,243329,169759,803041,1024879,883814,401507,6594,883585,934131,55366,132111,117745,789824,552267,875034,584565,364161,422578,1041730,606236,1029495,740456,988390,201517,956453,30538,25096,73410,550566,299693,688070,961370,846560,211751,842707,336051,186271,539190,312435,976010,803199,407164,885522,288489,758009,796265,6497,134832,231407,781339,739693,948843,504492,445467,46999,597352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004402s ]