SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506538 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506538 [ RunTime:0.002592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047880,1037908,40056,403915,505199,535063,315171,915086,871639,209070,347099,653809,940103,105539,173953,709706,355746,797565,575175,6405,924089,587409,83963,17573,261072,26750,564966,251601,441358,992233,539024,372008,34988,319735,411310,41509,544893,121762,425831,943287,971354,751802,954726,620846,950483,921543,314806,6726,27478,354682,858982,475714,950265,141002,461619,218156,519719,371549,263021,365777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]