SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504719 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504719 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542181,609605,802632,822583,562099,969791,129511,441427,1009216,280623,445666,345468,732640,157826,255251,701469,371197,289290,991205,36274,634081,136694,76833,971914,746424,384786,552303,706608,656087,337419,82933,132513,983923,121728,297722,544902,297675,528827,156343,251342,432558,563712,692727,380286,396960,861114,951040,974699,115217,847351,572791,175698,274616,404857,183817,596418,808959,623614,439605,582267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504719 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504719 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]