SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521897 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521897 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65289,116904,347604,596103,147199,381810,286869,865139,304238,312739,645771,149804,1039841,762068,842875,540599,272268,1019421,905763,661500,352431,731519,457488,730775,267799,487804,701326,377867,135846,406930,380087,49869,11810,769761,819095,809080,596817,202243,39298,129566,880678,196292,867032,933711,292062,870423,570120,959404,275638,8793,1012364,493445,179645,187290,559921,558279,201515,567053,812060,309533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]