SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534273 LIMIT 1 [ RunTime:0.001245s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534273 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35777,736011,308139,743922,232917,1023273,318978,560252,124508,934457,884703,829144,930130,438041,574502,616541,786014,431410,1019718,543078,103329,710348,761164,470689,410900,149146,332257,766622,390637,895294,771312,582521,148145,884411,419238,732377,352859,37323,648781,172442,576030,531461,344359,619441,987621,772553,512203,142434,70511,164421,688000,84516,365971,61496,641468,527536,985142,619896,229913,881318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001321s ]