SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427178 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427178 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728554,960642,239798,171052,569327,576908,633585,858810,505364,697746,258175,117003,614808,313930,901612,649549,1020819,965619,492622,588819,934549,506439,209152,546528,303785,954793,194914,645309,289835,465151,874789,105844,113227,238839,1026336,973421,973195,28733,174764,57738,126707,65859,212632,250748,861938,860878,546713,485035,549105,866791,640717,701806,337917,214112,904277,843691,645873,783227,531155,920095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]