SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520131 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520131 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25795,493667,642700,527054,51672,84126,771298,277198,591398,185302,725897,128029,210564,176312,9425,407908,467685,631952,570644,1034503,98312,626957,807360,181222,410401,479467,450718,887167,489183,40439,651297,599219,7003,756073,573126,963074,248171,295746,127055,46453,858852,32657,114021,679845,379312,706025,70604,154153,1030950,963418,1047952,131141,301056,460986,655938,567037,741998,533862,803736,45072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003001s ]