SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532320 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532320 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100647,960460,595938,331159,350280,857338,141297,693607,343174,327689,90269,660853,712010,156061,699127,705825,356262,155758,716769,272078,110945,708494,943798,85815,148322,1008107,280524,894879,657149,134949,720570,402158,539885,817894,473788,519080,885216,466375,291374,583710,686297,640390,783835,574383,518096,480094,925439,875649,446370,124477,33832,506670,468469,704219,985494,781605,594890,647745,548060,1023850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]