SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305651 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305651 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (237293,414392,252438,677186,114381,202565,966138,950489,398413,135028,106039,777913,912033,11963,756581,921051,859437,820936,263360,357355,404586,1018932,437607,863732,326081,615117,931382,916012,576603,618147,189194,14443,114056,447396,157608,381961,174581,796175,941546,277952,778045,911577,590049,744768,76776,910674,874338,454049,834859,479939,182969,369613,59795,504323,814760,291808,1025793,326827,295044,958720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002249s ]