SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001957 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001957 [ RunTime:0.002244s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019430,569831,431378,442568,1000558,286215,126340,401481,741357,257819,846828,421558,700863,557224,25185,212281,979141,460364,121307,154939,93544,804734,977845,946222,368999,496316,428515,438953,321770,39338,885158,238992,1005931,404368,314771,959489,847187,440336,426249,24330,633149,723900,989578,68157,1013921,41600,256973,604587,867468,428203,8983,980700,123335,856424,567492,512380,153549,883845,131564,569254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001300s ]