SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333851 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333851 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542980,1999,71636,352955,318032,447903,315605,677084,581463,980168,635768,13980,261103,132485,604649,271128,869106,170261,410048,242175,466021,696997,438988,588558,421733,62294,540605,445264,777535,19288,955481,728434,246605,334800,128025,377563,261776,753245,867154,1004514,838099,1015146,466608,430663,816619,922552,998821,168258,769556,372699,707095,298797,206614,344891,335401,885898,351466,113535,91355,925716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]