SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001240 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001240 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18653,849931,56851,239157,842812,875371,699567,113434,818194,325896,502797,388469,1011123,141873,183812,463789,170281,992149,172698,453786,248634,644574,634320,22898,763802,167341,944522,152673,760613,57229,352076,365968,404998,974398,522375,405151,975510,39616,971310,258913,776697,962316,555045,215329,763368,786330,865433,735161,571443,1031467,405698,781980,1027352,954173,185140,877070,238718,447208,186168,224815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]