SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019675 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019675 [ RunTime:0.003904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140288,110798,813802,252844,601398,762009,311532,570489,1010268,1671,688874,530756,417488,334768,286274,247128,856645,357319,403030,1006356,213839,682522,12739,263558,769461,824819,391702,914276,820638,792099,832077,727452,488129,722634,149048,788916,715275,997413,788414,899483,484401,271580,602253,732941,70526,271901,791242,65873,451438,473028,64096,794771,396109,257893,627665,6533,470225,570372,628422,169411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019675 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019675 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]