SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017405 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017405 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323464,79453,792156,644476,28079,110561,503838,565864,38834,951701,961172,323509,51179,350727,614402,914201,555195,1001445,261339,1017167,439314,315342,223945,322955,609590,991147,371530,862506,1037413,950288,472875,1044658,774079,353533,920854,231397,534321,698420,1033883,350905,9082,131828,536442,918103,913533,9923,348525,920121,399369,842362,575797,751527,887074,117583,1030963,288842,681181,828773,382433,453718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]