SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457611 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457611 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710951,768944,277860,1038343,233828,306878,442990,3058,111572,744979,291195,856637,971282,68079,572001,273122,1029898,264144,816951,53559,147440,391605,1018562,808959,611749,954803,1028179,31182,496005,689213,598376,307378,459035,789799,786375,532956,261076,973886,534731,243419,380588,710061,841830,759483,228441,148273,185981,530958,660532,966607,255791,495731,967651,385234,873504,643176,67842,952912,815691,1026980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]