SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303143 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303143 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904850,47028,843058,36056,719847,336563,1030596,138074,938753,462641,622761,374467,85468,821933,494620,311220,122149,706085,503889,515947,874760,450142,300092,868361,682758,687501,867022,688661,940090,387771,891415,331232,645843,315128,885551,441552,404333,1031117,1039503,184660,214527,33458,590020,683903,164503,372153,393953,107160,426015,159661,413737,972348,827901,462393,246151,638800,807054,876058,529800,3233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]