SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301508 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301508 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713778,499234,709131,231267,932434,223686,123732,875951,1012227,514130,182981,688441,511516,1031490,996041,41362,619416,258113,679119,329291,59750,702697,718904,405886,225964,593721,1032194,104056,703821,661939,810160,737561,141012,319820,114197,875131,24469,836779,515482,417026,590050,166043,893024,343927,922436,658438,331555,835684,389691,813741,119109,822052,805447,985063,881638,1004880,706641,414229,812374,226442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]