SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501739 LIMIT 1 [ RunTime:0.002513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501739 [ RunTime:0.002178s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404875,583872,738720,159386,695088,550320,114613,301093,761293,72437,247968,422122,628093,598314,625479,911043,327811,645713,838440,808435,264216,468599,109837,594581,927142,186241,322076,378609,258160,153568,172913,957435,813057,462462,189096,78632,565619,22637,585694,98354,905925,698754,787695,200664,990531,279232,544126,753087,430198,492069,178900,184764,119806,639979,138883,402270,394610,161640,1008228,229863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004751s ]