SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501715 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501715 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334975,41280,23040,194349,300873,169238,1026701,262402,161840,189114,842770,372429,927502,459796,786302,448004,234805,405420,365256,469187,370184,439093,579192,539857,11914,997519,166968,558321,387499,846945,561220,292334,709657,76189,347654,690091,922974,941983,477030,854341,30908,233359,659442,61296,130788,767828,339955,447171,909385,1022691,467769,875868,354982,175966,323263,256093,111232,828334,254894,833129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]