SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498650 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498650 [ RunTime:0.005462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (929152,226388,162076,344514,834438,786060,95906,741747,1039403,692872,432321,1031877,869496,505715,204971,419515,682784,319507,566799,313985,983385,623933,1000478,211244,828395,589637,822629,409764,554106,189421,203929,1030066,288880,1007770,702058,219369,541063,845234,104783,320697,1031755,974132,90618,436924,136050,316003,832818,35140,654658,305584,602258,400130,499239,754019,746563,924826,573210,65388,729638,182563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]