SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149513 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149513 [ RunTime:0.001781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791020,76732,367333,39650,105619,820114,132665,369342,269116,938155,548105,129423,487421,760495,956245,501455,690617,157428,340967,358666,770968,351529,193431,182140,811977,963647,354205,839547,801593,927350,573795,628310,277493,397267,283974,731901,744768,7017,948775,860274,400768,663561,968643,575712,600623,525223,33206,158844,658032,482670,671646,512034,383924,980068,101490,135499,482635,578699,874796,62800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]