SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017972 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017972 [ RunTime:0.005325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (893913,875708,246039,288959,385100,574445,293066,78582,602818,47113,281424,225315,36172,307510,148275,467074,639476,73598,88912,792276,451222,444602,547801,759372,605071,927990,820234,706029,147895,105191,540123,649522,652054,864598,441729,529388,357630,531768,469281,776715,527429,324104,19041,268532,215066,871560,730581,911337,892446,547,336249,784219,192014,884351,91210,69977,728448,432587,209965,132318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017972 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000870s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017972 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]