SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511043 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511043 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505709,146408,390471,299205,330600,706093,349070,439859,224774,188139,843868,712533,181203,205851,200012,1018389,499829,705336,581692,118256,473956,543367,974411,72557,180458,980159,376335,241342,262838,1034980,426870,889955,885282,316547,186299,776625,201270,430383,1012030,454312,180620,445735,64540,603623,731490,258968,568994,764255,942129,920135,553179,1019883,241187,552428,785001,961121,1038180,503075,561827,737737) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003182s ]