SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554335 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554335 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264286,406138,475531,219768,261545,489561,821619,540624,450241,156984,773934,104663,357154,152181,127973,1028069,302092,303873,633167,476947,812439,726274,825573,65476,1006651,297476,686312,832951,259037,547215,466301,282619,991401,548117,355754,685359,86305,258775,663410,751569,482133,126612,481658,712605,826885,49292,747,646877,538985,5590,802346,156009,569269,265171,787742,293678,188268,996185,341910,326006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]