SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681715 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681715 [ RunTime:0.002131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705643,660376,1046485,264398,34283,20180,831846,572996,804310,261881,880558,794299,56965,1014400,164404,603405,734326,275452,149283,512491,891065,569612,896698,1002147,258845,28447,715888,957917,1019956,561455,899945,86119,380831,224893,313832,203031,107882,110597,1031179,1006403,845940,984407,216307,178985,520551,559356,493,488044,442894,164049,778465,658334,906129,352454,865970,8836,679317,415605,43336,450080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]