SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005894 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005894 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028200,1046293,760604,91641,839751,169322,800510,526756,1038136,557778,789116,876237,487629,741344,344866,923310,486860,281639,859120,894307,1045945,454569,1037762,860946,688739,839851,1005064,117741,552402,972886,429354,444709,466800,857904,1039397,106725,39368,588385,113124,830231,191751,219988,815694,326190,340631,926091,224263,152300,371299,380014,327531,396971,780994,645666,785364,938006,913779,787598,575215,592896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]