SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111089 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111089 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812132,785892,605076,665809,651350,495382,135034,232123,288547,385758,751414,542412,784048,831476,900953,1031278,119543,526799,271578,436674,704574,614403,94556,225196,350503,604579,363253,1043442,226648,323878,179580,535330,286010,178285,519917,40008,98686,172342,38874,566000,1008937,1000995,499139,519281,134338,756778,589365,768280,279259,320711,8508,657450,303635,642727,230329,350081,1003393,565883,969140,397558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]