SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002388s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104981 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104981 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307077,265001,998577,699102,576680,70778,126922,950330,815587,593491,776758,436818,879794,513039,709876,258832,444970,508623,509387,56043,837776,609199,192764,832102,86863,603709,939245,596570,682540,157977,303791,130028,531993,609934,55844,537880,411830,150069,461484,92467,431287,588797,561820,918039,876557,604400,744325,579495,288208,485332,64286,661493,215977,119000,966227,941294,123677,103363,8326,873598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]