SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267380 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267380 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28327,716760,139098,617510,983385,997860,2575,332411,728439,947305,381048,322299,476867,478658,579550,499851,830972,872905,801700,341209,1001996,353821,504322,548152,937964,320587,104917,379146,131384,641721,816126,912336,792143,482530,726921,754055,231641,213461,292721,283399,780124,90182,3742,259688,910542,99843,776727,759193,1004230,210030,550692,445209,582408,170822,719283,170414,526710,663662,738341,156169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]